
CREATE INDEX "is_isoMetadata" ON "ISOMetadata" ("MetadataLink" ASC);
CREATE INDEX "ix_DataSeries" ON "DataSeries" ("SiteID" ASC, "VariableID" ASC, "MethodID" ASC, "SourceID" ASC, "QualityControlLevelID" ASC);
CREATE UNIQUE INDEX "ix_DataThemeDescriptionId" ON "DataThemeDescriptions" ("ThemeID" ASC);
CREATE UNIQUE INDEX "ix_MethodId" ON "Methods" ("MethodID" ASC);
CREATE INDEX "ix_dataService" ON "DataServices" ("ServiceEndpointURL" ASC);
CREATE UNIQUE INDEX "ix_dataServiceId" ON "DataServices" ("ServiceID" ASC);
CREATE INDEX "ix_dataTheme" ON "DataThemeDescriptions" ("ThemeName" ASC, "ThemeDescription" ASC);
CREATE UNIQUE INDEX "ix_dataseriesId" ON "DataSeries" ("SeriesID" ASC);
CREATE UNIQUE INDEX "ix_isoMdId" ON "ISOMetadata" ("MetadataID" ASC);
CREATE INDEX "ix_method" ON "Methods" ("MethodDescription" ASC, "MethodLink" ASC);
CREATE INDEX "ix_qc" ON "QualityControlLevels" ("QualityControlLevelCode" ASC, "Definition" ASC);
CREATE UNIQUE INDEX "ix_qcId" ON "QualityControlLevels" ("QualityControlLevelID" ASC);
CREATE INDEX "ix_qualfier" ON "Qualifiers" ("QualifierCode" ASC, "QualifierDescription" ASC);
CREATE UNIQUE INDEX "ix_qualifierId" ON "Qualifiers" ("QualifierID" ASC);
CREATE INDEX "ix_siteId" ON "Sites" ("SiteID" ASC);
CREATE INDEX "ix_siteSearch" ON "Sites" ("SiteCode" ASC);
CREATE UNIQUE INDEX "ix_sourceId" ON "Sources" ("SourceID" ASC);
CREATE INDEX "ix_sources" ON "Sources" ("Organization" ASC);
CREATE UNIQUE INDEX "ix_spatialReferencId" ON "SpatialReferences" ("SpatialReferenceID" ASC);
CREATE INDEX "ix_spatialReference" ON "SpatialReferences" ("SRSName" ASC);
CREATE INDEX "ix_unit" ON "Units" ("UnitsName" ASC, "UnitsAbbreviation" ASC);
CREATE UNIQUE INDEX "ix_unitId" ON "Units" ("UnitsID" ASC);
CREATE UNIQUE INDEX "ix_variableId" ON "Variables" ("VariableID" ASC);
CREATE INDEX "ix_variableSearch" ON "Variables" ("VariableCode" ASC);

